﻿CREATE VIEW [dbo].[EmploeeTask]
	AS SELECT Employee.emp_id, Employee.Name, TaskTable.task_name, TaskTable.task_id, TaskTable.task_description, WorkFlow.flow_id, WorkFlow.flowStatus 
			FROM Employee INNER JOIN TaskTable ON Employee.emp_id = TaskTable.emp_id
			INNER JOIN WorkFlow ON TaskTable.flow_id = WorkFlow.flow_id